clear
set more off, perm
cd /Users/zachbrown/Projects/PriceTransparency/Data/

clear
insheet using healthcost_procedures/Procedure_codes_HealthCost_website.csv, delim(",") names

duplicates list proc_code if proc_code~=""

sort proc_broad
encode proc_broad, gen(procname)
drop proc_broad old_codes


merge m:1 proc_web_name using healthcost_procedures/proc_web_name_xwalk.dta

tab proc_web_name if _merge==1 
keep if _merge==3
drop _merge is_radiology proc_web_name

replace border_proc = 0 if border_proc==.

save healthcost_procedures/Procedure_codes_HealthCost_website_cpt.dta, replace


